﻿CREATE TABLE [dbo].[ServerDrive] (
    [ServerID]       INT             NOT NULL,
    [Drive]          CHAR(1)        NOT NULL,
    [FreeSpaceInGB]  DECIMAL (18, 2) NULL,
    [TotalSpaceInGB] DECIMAL (18, 2) NULL,
    CONSTRAINT [PK_ServerDrive_1] PRIMARY KEY CLUSTERED ([ServerID] ASC, [Drive] ASC),
    CONSTRAINT [FK_ServerDrive_Server] FOREIGN KEY ([ServerID]) REFERENCES [dbo].[Server] ([ServerID])
);

